﻿CREATE PROCEDURE [dbo].[Hogar_Vinculo_Insertar]   
 @Nombre VARCHAR (50)
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   crea un nuevo Vinculo
-- Returns:    Vinculo
/*****************************************************************************************************************************************/ 
	
	DECLARE @vinculoId int

	INSERT INTO [dbo].[Vinculo]
				(Descripcion)
	VALUES (@Nombre)

	SET @vinculoId = IDENT_CURRENT('Vinculo')

	SELECT  [VinculoId],
			[Descripcion]
	FROM	[dbo].[Vinculo] WITH (NOLOCK)
	WHERE [VinculoId] = @vinculoId
	
END